package com.literature.threeGroup.pojo;

import java.util.ArrayList;
import java.util.Date;
import java.util.List;

public class OrderExample {
    protected String orderByClause;

    protected boolean distinct;

    protected List<Criteria> oredCriteria;

    public OrderExample() {
        oredCriteria = new ArrayList<Criteria>();
    }

    public void setOrderByClause(String orderByClause) {
        this.orderByClause = orderByClause;
    }

    public String getOrderByClause() {
        return orderByClause;
    }

    public void setDistinct(boolean distinct) {
        this.distinct = distinct;
    }

    public boolean isDistinct() {
        return distinct;
    }

    public List<Criteria> getOredCriteria() {
        return oredCriteria;
    }

    public void or(Criteria criteria) {
        oredCriteria.add(criteria);
    }

    public Criteria or() {
        Criteria criteria = createCriteriaInternal();
        oredCriteria.add(criteria);
        return criteria;
    }

    public Criteria createCriteria() {
        Criteria criteria = createCriteriaInternal();
        if (oredCriteria.size() == 0) {
            oredCriteria.add(criteria);
        }
        return criteria;
    }

    protected Criteria createCriteriaInternal() {
        Criteria criteria = new Criteria();
        return criteria;
    }

    public void clear() {
        oredCriteria.clear();
        orderByClause = null;
        distinct = false;
    }

    protected abstract static class GeneratedCriteria {
        protected List<Criterion> criteria;

        protected GeneratedCriteria() {
            super();
            criteria = new ArrayList<Criterion>();
        }

        public boolean isValid() {
            return criteria.size() > 0;
        }

        public List<Criterion> getAllCriteria() {
            return criteria;
        }

        public List<Criterion> getCriteria() {
            return criteria;
        }

        protected void addCriterion(String condition) {
            if (condition == null) {
                throw new RuntimeException("Value for condition cannot be null");
            }
            criteria.add(new Criterion(condition));
        }

        protected void addCriterion(String condition, Object value, String property) {
            if (value == null) {
                throw new RuntimeException("Value for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value));
        }

        protected void addCriterion(String condition, Object value1, Object value2, String property) {
            if (value1 == null || value2 == null) {
                throw new RuntimeException("Between values for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value1, value2));
        }

        public Criteria andIdIsNull() {
            addCriterion("id is null");
            return (Criteria) this;
        }

        public Criteria andIdIsNotNull() {
            addCriterion("id is not null");
            return (Criteria) this;
        }

        public Criteria andIdEqualTo(String value) {
            addCriterion("id =", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdNotEqualTo(String value) {
            addCriterion("id <>", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdGreaterThan(String value) {
            addCriterion("id >", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdGreaterThanOrEqualTo(String value) {
            addCriterion("id >=", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdLessThan(String value) {
            addCriterion("id <", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdLessThanOrEqualTo(String value) {
            addCriterion("id <=", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdLike(String value) {
            addCriterion("id like", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdNotLike(String value) {
            addCriterion("id not like", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdIn(List<String> values) {
            addCriterion("id in", values, "id");
            return (Criteria) this;
        }

        public Criteria andIdNotIn(List<String> values) {
            addCriterion("id not in", values, "id");
            return (Criteria) this;
        }

        public Criteria andIdBetween(String value1, String value2) {
            addCriterion("id between", value1, value2, "id");
            return (Criteria) this;
        }

        public Criteria andIdNotBetween(String value1, String value2) {
            addCriterion("id not between", value1, value2, "id");
            return (Criteria) this;
        }

        public Criteria andTitleIsNull() {
            addCriterion("title is null");
            return (Criteria) this;
        }

        public Criteria andTitleIsNotNull() {
            addCriterion("title is not null");
            return (Criteria) this;
        }

        public Criteria andTitleEqualTo(String value) {
            addCriterion("title =", value, "title");
            return (Criteria) this;
        }

        public Criteria andTitleNotEqualTo(String value) {
            addCriterion("title <>", value, "title");
            return (Criteria) this;
        }

        public Criteria andTitleGreaterThan(String value) {
            addCriterion("title >", value, "title");
            return (Criteria) this;
        }

        public Criteria andTitleGreaterThanOrEqualTo(String value) {
            addCriterion("title >=", value, "title");
            return (Criteria) this;
        }

        public Criteria andTitleLessThan(String value) {
            addCriterion("title <", value, "title");
            return (Criteria) this;
        }

        public Criteria andTitleLessThanOrEqualTo(String value) {
            addCriterion("title <=", value, "title");
            return (Criteria) this;
        }

        public Criteria andTitleLike(String value) {
            addCriterion("title like", value, "title");
            return (Criteria) this;
        }

        public Criteria andTitleNotLike(String value) {
            addCriterion("title not like", value, "title");
            return (Criteria) this;
        }

        public Criteria andTitleIn(List<String> values) {
            addCriterion("title in", values, "title");
            return (Criteria) this;
        }

        public Criteria andTitleNotIn(List<String> values) {
            addCriterion("title not in", values, "title");
            return (Criteria) this;
        }

        public Criteria andTitleBetween(String value1, String value2) {
            addCriterion("title between", value1, value2, "title");
            return (Criteria) this;
        }

        public Criteria andTitleNotBetween(String value1, String value2) {
            addCriterion("title not between", value1, value2, "title");
            return (Criteria) this;
        }

        public Criteria andOrderOrganizationIsNull() {
            addCriterion("order_organization is null");
            return (Criteria) this;
        }

        public Criteria andOrderOrganizationIsNotNull() {
            addCriterion("order_organization is not null");
            return (Criteria) this;
        }

        public Criteria andOrderOrganizationEqualTo(String value) {
            addCriterion("order_organization =", value, "orderOrganization");
            return (Criteria) this;
        }

        public Criteria andOrderOrganizationNotEqualTo(String value) {
            addCriterion("order_organization <>", value, "orderOrganization");
            return (Criteria) this;
        }

        public Criteria andOrderOrganizationGreaterThan(String value) {
            addCriterion("order_organization >", value, "orderOrganization");
            return (Criteria) this;
        }

        public Criteria andOrderOrganizationGreaterThanOrEqualTo(String value) {
            addCriterion("order_organization >=", value, "orderOrganization");
            return (Criteria) this;
        }

        public Criteria andOrderOrganizationLessThan(String value) {
            addCriterion("order_organization <", value, "orderOrganization");
            return (Criteria) this;
        }

        public Criteria andOrderOrganizationLessThanOrEqualTo(String value) {
            addCriterion("order_organization <=", value, "orderOrganization");
            return (Criteria) this;
        }

        public Criteria andOrderOrganizationLike(String value) {
            addCriterion("order_organization like", value, "orderOrganization");
            return (Criteria) this;
        }

        public Criteria andOrderOrganizationNotLike(String value) {
            addCriterion("order_organization not like", value, "orderOrganization");
            return (Criteria) this;
        }

        public Criteria andOrderOrganizationIn(List<String> values) {
            addCriterion("order_organization in", values, "orderOrganization");
            return (Criteria) this;
        }

        public Criteria andOrderOrganizationNotIn(List<String> values) {
            addCriterion("order_organization not in", values, "orderOrganization");
            return (Criteria) this;
        }

        public Criteria andOrderOrganizationBetween(String value1, String value2) {
            addCriterion("order_organization between", value1, value2, "orderOrganization");
            return (Criteria) this;
        }

        public Criteria andOrderOrganizationNotBetween(String value1, String value2) {
            addCriterion("order_organization not between", value1, value2, "orderOrganization");
            return (Criteria) this;
        }

        public Criteria andOrderYearIsNull() {
            addCriterion("order_year is null");
            return (Criteria) this;
        }

        public Criteria andOrderYearIsNotNull() {
            addCriterion("order_year is not null");
            return (Criteria) this;
        }

        public Criteria andOrderYearEqualTo(String value) {
            addCriterion("order_year =", value, "orderYear");
            return (Criteria) this;
        }

        public Criteria andOrderYearNotEqualTo(String value) {
            addCriterion("order_year <>", value, "orderYear");
            return (Criteria) this;
        }

        public Criteria andOrderYearGreaterThan(String value) {
            addCriterion("order_year >", value, "orderYear");
            return (Criteria) this;
        }

        public Criteria andOrderYearGreaterThanOrEqualTo(String value) {
            addCriterion("order_year >=", value, "orderYear");
            return (Criteria) this;
        }

        public Criteria andOrderYearLessThan(String value) {
            addCriterion("order_year <", value, "orderYear");
            return (Criteria) this;
        }

        public Criteria andOrderYearLessThanOrEqualTo(String value) {
            addCriterion("order_year <=", value, "orderYear");
            return (Criteria) this;
        }

        public Criteria andOrderYearLike(String value) {
            addCriterion("order_year like", value, "orderYear");
            return (Criteria) this;
        }

        public Criteria andOrderYearNotLike(String value) {
            addCriterion("order_year not like", value, "orderYear");
            return (Criteria) this;
        }

        public Criteria andOrderYearIn(List<String> values) {
            addCriterion("order_year in", values, "orderYear");
            return (Criteria) this;
        }

        public Criteria andOrderYearNotIn(List<String> values) {
            addCriterion("order_year not in", values, "orderYear");
            return (Criteria) this;
        }

        public Criteria andOrderYearBetween(String value1, String value2) {
            addCriterion("order_year between", value1, value2, "orderYear");
            return (Criteria) this;
        }

        public Criteria andOrderYearNotBetween(String value1, String value2) {
            addCriterion("order_year not between", value1, value2, "orderYear");
            return (Criteria) this;
        }

        public Criteria andAgencyCompanyIdIsNull() {
            addCriterion("agency_company_id is null");
            return (Criteria) this;
        }

        public Criteria andAgencyCompanyIdIsNotNull() {
            addCriterion("agency_company_id is not null");
            return (Criteria) this;
        }

        public Criteria andAgencyCompanyIdEqualTo(String value) {
            addCriterion("agency_company_id =", value, "agencyCompanyId");
            return (Criteria) this;
        }

        public Criteria andAgencyCompanyIdNotEqualTo(String value) {
            addCriterion("agency_company_id <>", value, "agencyCompanyId");
            return (Criteria) this;
        }

        public Criteria andAgencyCompanyIdGreaterThan(String value) {
            addCriterion("agency_company_id >", value, "agencyCompanyId");
            return (Criteria) this;
        }

        public Criteria andAgencyCompanyIdGreaterThanOrEqualTo(String value) {
            addCriterion("agency_company_id >=", value, "agencyCompanyId");
            return (Criteria) this;
        }

        public Criteria andAgencyCompanyIdLessThan(String value) {
            addCriterion("agency_company_id <", value, "agencyCompanyId");
            return (Criteria) this;
        }

        public Criteria andAgencyCompanyIdLessThanOrEqualTo(String value) {
            addCriterion("agency_company_id <=", value, "agencyCompanyId");
            return (Criteria) this;
        }

        public Criteria andAgencyCompanyIdLike(String value) {
            addCriterion("agency_company_id like", value, "agencyCompanyId");
            return (Criteria) this;
        }

        public Criteria andAgencyCompanyIdNotLike(String value) {
            addCriterion("agency_company_id not like", value, "agencyCompanyId");
            return (Criteria) this;
        }

        public Criteria andAgencyCompanyIdIn(List<String> values) {
            addCriterion("agency_company_id in", values, "agencyCompanyId");
            return (Criteria) this;
        }

        public Criteria andAgencyCompanyIdNotIn(List<String> values) {
            addCriterion("agency_company_id not in", values, "agencyCompanyId");
            return (Criteria) this;
        }

        public Criteria andAgencyCompanyIdBetween(String value1, String value2) {
            addCriterion("agency_company_id between", value1, value2, "agencyCompanyId");
            return (Criteria) this;
        }

        public Criteria andAgencyCompanyIdNotBetween(String value1, String value2) {
            addCriterion("agency_company_id not between", value1, value2, "agencyCompanyId");
            return (Criteria) this;
        }

        public Criteria andPayIsNull() {
            addCriterion("pay is null");
            return (Criteria) this;
        }

        public Criteria andPayIsNotNull() {
            addCriterion("pay is not null");
            return (Criteria) this;
        }

        public Criteria andPayEqualTo(Double value) {
            addCriterion("pay =", value, "pay");
            return (Criteria) this;
        }

        public Criteria andPayNotEqualTo(Double value) {
            addCriterion("pay <>", value, "pay");
            return (Criteria) this;
        }

        public Criteria andPayGreaterThan(Double value) {
            addCriterion("pay >", value, "pay");
            return (Criteria) this;
        }

        public Criteria andPayGreaterThanOrEqualTo(Double value) {
            addCriterion("pay >=", value, "pay");
            return (Criteria) this;
        }

        public Criteria andPayLessThan(Double value) {
            addCriterion("pay <", value, "pay");
            return (Criteria) this;
        }

        public Criteria andPayLessThanOrEqualTo(Double value) {
            addCriterion("pay <=", value, "pay");
            return (Criteria) this;
        }

        public Criteria andPayIn(List<Double> values) {
            addCriterion("pay in", values, "pay");
            return (Criteria) this;
        }

        public Criteria andPayNotIn(List<Double> values) {
            addCriterion("pay not in", values, "pay");
            return (Criteria) this;
        }

        public Criteria andPayBetween(Double value1, Double value2) {
            addCriterion("pay between", value1, value2, "pay");
            return (Criteria) this;
        }

        public Criteria andPayNotBetween(Double value1, Double value2) {
            addCriterion("pay not between", value1, value2, "pay");
            return (Criteria) this;
        }

        public Criteria andIsArrivalIsNull() {
            addCriterion("is_arrival is null");
            return (Criteria) this;
        }

        public Criteria andIsArrivalIsNotNull() {
            addCriterion("is_arrival is not null");
            return (Criteria) this;
        }

        public Criteria andIsArrivalEqualTo(String value) {
            addCriterion("is_arrival =", value, "isArrival");
            return (Criteria) this;
        }

        public Criteria andIsArrivalNotEqualTo(String value) {
            addCriterion("is_arrival <>", value, "isArrival");
            return (Criteria) this;
        }

        public Criteria andIsArrivalGreaterThan(String value) {
            addCriterion("is_arrival >", value, "isArrival");
            return (Criteria) this;
        }

        public Criteria andIsArrivalGreaterThanOrEqualTo(String value) {
            addCriterion("is_arrival >=", value, "isArrival");
            return (Criteria) this;
        }

        public Criteria andIsArrivalLessThan(String value) {
            addCriterion("is_arrival <", value, "isArrival");
            return (Criteria) this;
        }

        public Criteria andIsArrivalLessThanOrEqualTo(String value) {
            addCriterion("is_arrival <=", value, "isArrival");
            return (Criteria) this;
        }

        public Criteria andIsArrivalLike(String value) {
            addCriterion("is_arrival like", value, "isArrival");
            return (Criteria) this;
        }

        public Criteria andIsArrivalNotLike(String value) {
            addCriterion("is_arrival not like", value, "isArrival");
            return (Criteria) this;
        }

        public Criteria andIsArrivalIn(List<String> values) {
            addCriterion("is_arrival in", values, "isArrival");
            return (Criteria) this;
        }

        public Criteria andIsArrivalNotIn(List<String> values) {
            addCriterion("is_arrival not in", values, "isArrival");
            return (Criteria) this;
        }

        public Criteria andIsArrivalBetween(String value1, String value2) {
            addCriterion("is_arrival between", value1, value2, "isArrival");
            return (Criteria) this;
        }

        public Criteria andIsArrivalNotBetween(String value1, String value2) {
            addCriterion("is_arrival not between", value1, value2, "isArrival");
            return (Criteria) this;
        }

        public Criteria andEstimatedAmountIsNull() {
            addCriterion("estimated_amount is null");
            return (Criteria) this;
        }

        public Criteria andEstimatedAmountIsNotNull() {
            addCriterion("estimated_amount is not null");
            return (Criteria) this;
        }

        public Criteria andEstimatedAmountEqualTo(Double value) {
            addCriterion("estimated_amount =", value, "estimatedAmount");
            return (Criteria) this;
        }

        public Criteria andEstimatedAmountNotEqualTo(Double value) {
            addCriterion("estimated_amount <>", value, "estimatedAmount");
            return (Criteria) this;
        }

        public Criteria andEstimatedAmountGreaterThan(Double value) {
            addCriterion("estimated_amount >", value, "estimatedAmount");
            return (Criteria) this;
        }

        public Criteria andEstimatedAmountGreaterThanOrEqualTo(Double value) {
            addCriterion("estimated_amount >=", value, "estimatedAmount");
            return (Criteria) this;
        }

        public Criteria andEstimatedAmountLessThan(Double value) {
            addCriterion("estimated_amount <", value, "estimatedAmount");
            return (Criteria) this;
        }

        public Criteria andEstimatedAmountLessThanOrEqualTo(Double value) {
            addCriterion("estimated_amount <=", value, "estimatedAmount");
            return (Criteria) this;
        }

        public Criteria andEstimatedAmountIn(List<Double> values) {
            addCriterion("estimated_amount in", values, "estimatedAmount");
            return (Criteria) this;
        }

        public Criteria andEstimatedAmountNotIn(List<Double> values) {
            addCriterion("estimated_amount not in", values, "estimatedAmount");
            return (Criteria) this;
        }

        public Criteria andEstimatedAmountBetween(Double value1, Double value2) {
            addCriterion("estimated_amount between", value1, value2, "estimatedAmount");
            return (Criteria) this;
        }

        public Criteria andEstimatedAmountNotBetween(Double value1, Double value2) {
            addCriterion("estimated_amount not between", value1, value2, "estimatedAmount");
            return (Criteria) this;
        }



        public Criteria andFillingMoneyIsNull() {
            addCriterion("filling_money is null");
            return (Criteria) this;
        }

        public Criteria andFillingMoneyIsNotNull() {
            addCriterion("filling_money is not null");
            return (Criteria) this;
        }

        public Criteria andFillingMoneyEqualTo(Double value) {
            addCriterion("filling_money =", value, "fillingMoney");
            return (Criteria) this;
        }

        public Criteria andFillingMoneyNotEqualTo(Double value) {
            addCriterion("filling_money <>", value, "fillingMoney");
            return (Criteria) this;
        }

        public Criteria andFillingMoneyGreaterThan(Double value) {
            addCriterion("filling_money >", value, "fillingMoney");
            return (Criteria) this;
        }

        public Criteria andFillingMoneyGreaterThanOrEqualTo(Double value) {
            addCriterion("filling_money >=", value, "fillingMoney");
            return (Criteria) this;
        }

        public Criteria andFillingMoneyLessThan(Double value) {
            addCriterion("filling_money <", value, "fillingMoney");
            return (Criteria) this;
        }

        public Criteria andFillingMoneyLessThanOrEqualTo(Double value) {
            addCriterion("filling_money <=", value, "fillingMoney");
            return (Criteria) this;
        }

        public Criteria andFillingMoneyIn(List<Double> values) {
            addCriterion("filling_money in", values, "fillingMoney");
            return (Criteria) this;
        }

        public Criteria andFillingMoneyNotIn(List<Double> values) {
            addCriterion("filling_money not in", values, "fillingMoney");
            return (Criteria) this;
        }

        public Criteria andFillingMoneyBetween(Double value1, Double value2) {
            addCriterion("filling_money between", value1, value2, "fillingMoney");
            return (Criteria) this;
        }

        public Criteria andFillingMoneyNotBetween(Double value1, Double value2) {
            addCriterion("filling_money not between", value1, value2, "fillingMoney");
            return (Criteria) this;
        }

        public Criteria andDatabaseSupportIsNull() {
            addCriterion("\"database _support\" is null");
            return (Criteria) this;
        }

        public Criteria andDatabaseSupportIsNotNull() {
            addCriterion("\"database _support\" is not null");
            return (Criteria) this;
        }

        public Criteria andDatabaseSupportEqualTo(String value) {
            addCriterion("\"database _support\" =", value, "databaseSupport");
            return (Criteria) this;
        }

        public Criteria andDatabaseSupportNotEqualTo(String value) {
            addCriterion("\"database _support\" <>", value, "databaseSupport");
            return (Criteria) this;
        }

        public Criteria andDatabaseSupportGreaterThan(String value) {
            addCriterion("\"database _support\" >", value, "databaseSupport");
            return (Criteria) this;
        }

        public Criteria andDatabaseSupportGreaterThanOrEqualTo(String value) {
            addCriterion("\"database _support\" >=", value, "databaseSupport");
            return (Criteria) this;
        }

        public Criteria andDatabaseSupportLessThan(String value) {
            addCriterion("\"database _support\" <", value, "databaseSupport");
            return (Criteria) this;
        }

        public Criteria andDatabaseSupportLessThanOrEqualTo(String value) {
            addCriterion("\"database _support\" <=", value, "databaseSupport");
            return (Criteria) this;
        }

        public Criteria andDatabaseSupportLike(String value) {
            addCriterion("\"database _support\" like", value, "databaseSupport");
            return (Criteria) this;
        }

        public Criteria andDatabaseSupportNotLike(String value) {
            addCriterion("\"database _support\" not like", value, "databaseSupport");
            return (Criteria) this;
        }

        public Criteria andDatabaseSupportIn(List<String> values) {
            addCriterion("\"database _support\" in", values, "databaseSupport");
            return (Criteria) this;
        }

        public Criteria andDatabaseSupportNotIn(List<String> values) {
            addCriterion("\"database _support\" not in", values, "databaseSupport");
            return (Criteria) this;
        }

        public Criteria andDatabaseSupportBetween(String value1, String value2) {
            addCriterion("\"database _support\" between", value1, value2, "databaseSupport");
            return (Criteria) this;
        }

        public Criteria andDatabaseSupportNotBetween(String value1, String value2) {
            addCriterion("\"database _support\" not between", value1, value2, "databaseSupport");
            return (Criteria) this;
        }

        public Criteria andCarrierIsNull() {
            addCriterion("carrier is null");
            return (Criteria) this;
        }

        public Criteria andCarrierIsNotNull() {
            addCriterion("carrier is not null");
            return (Criteria) this;
        }

        public Criteria andCarrierEqualTo(String value) {
            addCriterion("carrier =", value, "carrier");
            return (Criteria) this;
        }

        public Criteria andCarrierNotEqualTo(String value) {
            addCriterion("carrier <>", value, "carrier");
            return (Criteria) this;
        }

        public Criteria andCarrierGreaterThan(String value) {
            addCriterion("carrier >", value, "carrier");
            return (Criteria) this;
        }

        public Criteria andCarrierGreaterThanOrEqualTo(String value) {
            addCriterion("carrier >=", value, "carrier");
            return (Criteria) this;
        }

        public Criteria andCarrierLessThan(String value) {
            addCriterion("carrier <", value, "carrier");
            return (Criteria) this;
        }

        public Criteria andCarrierLessThanOrEqualTo(String value) {
            addCriterion("carrier <=", value, "carrier");
            return (Criteria) this;
        }

        public Criteria andCarrierLike(String value) {
            addCriterion("carrier like", value, "carrier");
            return (Criteria) this;
        }

        public Criteria andCarrierNotLike(String value) {
            addCriterion("carrier not like", value, "carrier");
            return (Criteria) this;
        }

        public Criteria andCarrierIn(List<String> values) {
            addCriterion("carrier in", values, "carrier");
            return (Criteria) this;
        }

        public Criteria andCarrierNotIn(List<String> values) {
            addCriterion("carrier not in", values, "carrier");
            return (Criteria) this;
        }

        public Criteria andCarrierBetween(String value1, String value2) {
            addCriterion("carrier between", value1, value2, "carrier");
            return (Criteria) this;
        }

        public Criteria andCarrierNotBetween(String value1, String value2) {
            addCriterion("carrier not between", value1, value2, "carrier");
            return (Criteria) this;
        }

        public Criteria andOrderTypeIsNull() {
            addCriterion("order_type is null");
            return (Criteria) this;
        }

        public Criteria andOrderTypeIsNotNull() {
            addCriterion("order_type is not null");
            return (Criteria) this;
        }

        public Criteria andOrderTypeEqualTo(String value) {
            addCriterion("order_type =", value, "orderType");
            return (Criteria) this;
        }

        public Criteria andOrderTypeNotEqualTo(String value) {
            addCriterion("order_type <>", value, "orderType");
            return (Criteria) this;
        }

        public Criteria andOrderTypeGreaterThan(String value) {
            addCriterion("order_type >", value, "orderType");
            return (Criteria) this;
        }

        public Criteria andOrderTypeGreaterThanOrEqualTo(String value) {
            addCriterion("order_type >=", value, "orderType");
            return (Criteria) this;
        }

        public Criteria andOrderTypeLessThan(String value) {
            addCriterion("order_type <", value, "orderType");
            return (Criteria) this;
        }

        public Criteria andOrderTypeLessThanOrEqualTo(String value) {
            addCriterion("order_type <=", value, "orderType");
            return (Criteria) this;
        }

        public Criteria andOrderTypeLike(String value) {
            addCriterion("order_type like", value, "orderType");
            return (Criteria) this;
        }

        public Criteria andOrderTypeNotLike(String value) {
            addCriterion("order_type not like", value, "orderType");
            return (Criteria) this;
        }

        public Criteria andOrderTypeIn(List<String> values) {
            addCriterion("order_type in", values, "orderType");
            return (Criteria) this;
        }

        public Criteria andOrderTypeNotIn(List<String> values) {
            addCriterion("order_type not in", values, "orderType");
            return (Criteria) this;
        }

        public Criteria andOrderTypeBetween(String value1, String value2) {
            addCriterion("order_type between", value1, value2, "orderType");
            return (Criteria) this;
        }

        public Criteria andOrderTypeNotBetween(String value1, String value2) {
            addCriterion("order_type not between", value1, value2, "orderType");
            return (Criteria) this;
        }

        public Criteria andReviewStatusIsNull() {
            addCriterion("review_status is null");
            return (Criteria) this;
        }

        public Criteria andReviewStatusIsNotNull() {
            addCriterion("review_status is not null");
            return (Criteria) this;
        }

        public Criteria andReviewStatusEqualTo(String value) {
            addCriterion("review_status =", value, "reviewStatus");
            return (Criteria) this;
        }

        public Criteria andReviewStatusNotEqualTo(String value) {
            addCriterion("review_status <>", value, "reviewStatus");
            return (Criteria) this;
        }

        public Criteria andReviewStatusGreaterThan(String value) {
            addCriterion("review_status >", value, "reviewStatus");
            return (Criteria) this;
        }

        public Criteria andReviewStatusGreaterThanOrEqualTo(String value) {
            addCriterion("review_status >=", value, "reviewStatus");
            return (Criteria) this;
        }

        public Criteria andReviewStatusLessThan(String value) {
            addCriterion("review_status <", value, "reviewStatus");
            return (Criteria) this;
        }

        public Criteria andReviewStatusLessThanOrEqualTo(String value) {
            addCriterion("review_status <=", value, "reviewStatus");
            return (Criteria) this;
        }

        public Criteria andReviewStatusLike(String value) {
            addCriterion("review_status like", value, "reviewStatus");
            return (Criteria) this;
        }

        public Criteria andReviewStatusNotLike(String value) {
            addCriterion("review_status not like", value, "reviewStatus");
            return (Criteria) this;
        }

        public Criteria andReviewStatusIn(List<String> values) {
            addCriterion("review_status in", values, "reviewStatus");
            return (Criteria) this;
        }

        public Criteria andReviewStatusNotIn(List<String> values) {
            addCriterion("review_status not in", values, "reviewStatus");
            return (Criteria) this;
        }

        public Criteria andReviewStatusBetween(String value1, String value2) {
            addCriterion("review_status between", value1, value2, "reviewStatus");
            return (Criteria) this;
        }

        public Criteria andReviewStatusNotBetween(String value1, String value2) {
            addCriterion("review_status not between", value1, value2, "reviewStatus");
            return (Criteria) this;
        }

        public Criteria andDoorNoIdIsNull() {
            addCriterion("door_no_id is null");
            return (Criteria) this;
        }

        public Criteria andDoorNoIdIsNotNull() {
            addCriterion("door_no_id is not null");
            return (Criteria) this;
        }

        public Criteria andDoorNoIdEqualTo(String value) {
            addCriterion("door_no_id =", value, "doorNoId");
            return (Criteria) this;
        }

        public Criteria andDoorNoIdNotEqualTo(String value) {
            addCriterion("door_no_id <>", value, "doorNoId");
            return (Criteria) this;
        }

        public Criteria andDoorNoIdGreaterThan(String value) {
            addCriterion("door_no_id >", value, "doorNoId");
            return (Criteria) this;
        }

        public Criteria andDoorNoIdGreaterThanOrEqualTo(String value) {
            addCriterion("door_no_id >=", value, "doorNoId");
            return (Criteria) this;
        }

        public Criteria andDoorNoIdLessThan(String value) {
            addCriterion("door_no_id <", value, "doorNoId");
            return (Criteria) this;
        }

        public Criteria andDoorNoIdLessThanOrEqualTo(String value) {
            addCriterion("door_no_id <=", value, "doorNoId");
            return (Criteria) this;
        }

        public Criteria andDoorNoIdLike(String value) {
            addCriterion("door_no_id like", value, "doorNoId");
            return (Criteria) this;
        }

        public Criteria andDoorNoIdNotLike(String value) {
            addCriterion("door_no_id not like", value, "doorNoId");
            return (Criteria) this;
        }

        public Criteria andDoorNoIdIn(List<String> values) {
            addCriterion("door_no_id in", values, "doorNoId");
            return (Criteria) this;
        }

        public Criteria andDoorNoIdNotIn(List<String> values) {
            addCriterion("door_no_id not in", values, "doorNoId");
            return (Criteria) this;
        }

        public Criteria andDoorNoIdBetween(String value1, String value2) {
            addCriterion("door_no_id between", value1, value2, "doorNoId");
            return (Criteria) this;
        }

        public Criteria andDoorNoIdNotBetween(String value1, String value2) {
            addCriterion("door_no_id not between", value1, value2, "doorNoId");
            return (Criteria) this;
        }

        public Criteria andFinancialSupportIdIsNull() {
            addCriterion("financial_support_id is null");
            return (Criteria) this;
        }

        public Criteria andFinancialSupportIdIsNotNull() {
            addCriterion("financial_support_id is not null");
            return (Criteria) this;
        }

        public Criteria andFinancialSupportIdEqualTo(String value) {
            addCriterion("financial_support_id =", value, "financialSupportId");
            return (Criteria) this;
        }

        public Criteria andFinancialSupportIdNotEqualTo(String value) {
            addCriterion("financial_support_id <>", value, "financialSupportId");
            return (Criteria) this;
        }

        public Criteria andFinancialSupportIdGreaterThan(String value) {
            addCriterion("financial_support_id >", value, "financialSupportId");
            return (Criteria) this;
        }

        public Criteria andFinancialSupportIdGreaterThanOrEqualTo(String value) {
            addCriterion("financial_support_id >=", value, "financialSupportId");
            return (Criteria) this;
        }

        public Criteria andFinancialSupportIdLessThan(String value) {
            addCriterion("financial_support_id <", value, "financialSupportId");
            return (Criteria) this;
        }

        public Criteria andFinancialSupportIdLessThanOrEqualTo(String value) {
            addCriterion("financial_support_id <=", value, "financialSupportId");
            return (Criteria) this;
        }

        public Criteria andFinancialSupportIdLike(String value) {
            addCriterion("financial_support_id like", value, "financialSupportId");
            return (Criteria) this;
        }

        public Criteria andFinancialSupportIdNotLike(String value) {
            addCriterion("financial_support_id not like", value, "financialSupportId");
            return (Criteria) this;
        }

        public Criteria andFinancialSupportIdIn(List<String> values) {
            addCriterion("financial_support_id in", values, "financialSupportId");
            return (Criteria) this;
        }

        public Criteria andFinancialSupportIdNotIn(List<String> values) {
            addCriterion("financial_support_id not in", values, "financialSupportId");
            return (Criteria) this;
        }

        public Criteria andFinancialSupportIdBetween(String value1, String value2) {
            addCriterion("financial_support_id between", value1, value2, "financialSupportId");
            return (Criteria) this;
        }

        public Criteria andFinancialSupportIdNotBetween(String value1, String value2) {
            addCriterion("financial_support_id not between", value1, value2, "financialSupportId");
            return (Criteria) this;
        }

        public Criteria andIsOrderIsNull() {
            addCriterion("is_order is null");
            return (Criteria) this;
        }

        public Criteria andIsOrderIsNotNull() {
            addCriterion("is_order is not null");
            return (Criteria) this;
        }

        public Criteria andIsOrderEqualTo(String value) {
            addCriterion("is_order =", value, "isOrder");
            return (Criteria) this;
        }

        public Criteria andIsOrderNotEqualTo(String value) {
            addCriterion("is_order <>", value, "isOrder");
            return (Criteria) this;
        }

        public Criteria andIsOrderGreaterThan(String value) {
            addCriterion("is_order >", value, "isOrder");
            return (Criteria) this;
        }

        public Criteria andIsOrderGreaterThanOrEqualTo(String value) {
            addCriterion("is_order >=", value, "isOrder");
            return (Criteria) this;
        }

        public Criteria andIsOrderLessThan(String value) {
            addCriterion("is_order <", value, "isOrder");
            return (Criteria) this;
        }

        public Criteria andIsOrderLessThanOrEqualTo(String value) {
            addCriterion("is_order <=", value, "isOrder");
            return (Criteria) this;
        }

        public Criteria andIsOrderLike(String value) {
            addCriterion("is_order like", value, "isOrder");
            return (Criteria) this;
        }

        public Criteria andIsOrderNotLike(String value) {
            addCriterion("is_order not like", value, "isOrder");
            return (Criteria) this;
        }

        public Criteria andIsOrderIn(List<String> values) {
            addCriterion("is_order in", values, "isOrder");
            return (Criteria) this;
        }

        public Criteria andIsOrderNotIn(List<String> values) {
            addCriterion("is_order not in", values, "isOrder");
            return (Criteria) this;
        }

        public Criteria andIsOrderBetween(String value1, String value2) {
            addCriterion("is_order between", value1, value2, "isOrder");
            return (Criteria) this;
        }

        public Criteria andIsOrderNotBetween(String value1, String value2) {
            addCriterion("is_order not between", value1, value2, "isOrder");
            return (Criteria) this;
        }

        public Criteria andForeignPriceIsNull() {
            addCriterion("foreign_price is null");
            return (Criteria) this;
        }

        public Criteria andForeignPriceIsNotNull() {
            addCriterion("foreign_price is not null");
            return (Criteria) this;
        }

        public Criteria andForeignPriceEqualTo(Double value) {
            addCriterion("foreign_price =", value, "foreignPrice");
            return (Criteria) this;
        }

        public Criteria andForeignPriceNotEqualTo(Double value) {
            addCriterion("foreign_price <>", value, "foreignPrice");
            return (Criteria) this;
        }

        public Criteria andForeignPriceGreaterThan(Double value) {
            addCriterion("foreign_price >", value, "foreignPrice");
            return (Criteria) this;
        }

        public Criteria andForeignPriceGreaterThanOrEqualTo(Double value) {
            addCriterion("foreign_price >=", value, "foreignPrice");
            return (Criteria) this;
        }

        public Criteria andForeignPriceLessThan(Double value) {
            addCriterion("foreign_price <", value, "foreignPrice");
            return (Criteria) this;
        }

        public Criteria andForeignPriceLessThanOrEqualTo(Double value) {
            addCriterion("foreign_price <=", value, "foreignPrice");
            return (Criteria) this;
        }

        public Criteria andForeignPriceIn(List<Double> values) {
            addCriterion("foreign_price in", values, "foreignPrice");
            return (Criteria) this;
        }

        public Criteria andForeignPriceNotIn(List<Double> values) {
            addCriterion("foreign_price not in", values, "foreignPrice");
            return (Criteria) this;
        }

        public Criteria andForeignPriceBetween(Double value1, Double value2) {
            addCriterion("foreign_price between", value1, value2, "foreignPrice");
            return (Criteria) this;
        }

        public Criteria andForeignPriceNotBetween(Double value1, Double value2) {
            addCriterion("foreign_price not between", value1, value2, "foreignPrice");
            return (Criteria) this;
        }

        public Criteria andReturnPriceIsNull() {
            addCriterion("return_price is null");
            return (Criteria) this;
        }

        public Criteria andReturnPriceIsNotNull() {
            addCriterion("return_price is not null");
            return (Criteria) this;
        }

        public Criteria andReturnPriceEqualTo(Double value) {
            addCriterion("return_price =", value, "returnPrice");
            return (Criteria) this;
        }

        public Criteria andReturnPriceNotEqualTo(Double value) {
            addCriterion("return_price <>", value, "returnPrice");
            return (Criteria) this;
        }

        public Criteria andReturnPriceGreaterThan(Double value) {
            addCriterion("return_price >", value, "returnPrice");
            return (Criteria) this;
        }

        public Criteria andReturnPriceGreaterThanOrEqualTo(Double value) {
            addCriterion("return_price >=", value, "returnPrice");
            return (Criteria) this;
        }

        public Criteria andReturnPriceLessThan(Double value) {
            addCriterion("return_price <", value, "returnPrice");
            return (Criteria) this;
        }

        public Criteria andReturnPriceLessThanOrEqualTo(Double value) {
            addCriterion("return_price <=", value, "returnPrice");
            return (Criteria) this;
        }

        public Criteria andReturnPriceIn(List<Double> values) {
            addCriterion("return_price in", values, "returnPrice");
            return (Criteria) this;
        }

        public Criteria andReturnPriceNotIn(List<Double> values) {
            addCriterion("return_price not in", values, "returnPrice");
            return (Criteria) this;
        }

        public Criteria andReturnPriceBetween(Double value1, Double value2) {
            addCriterion("return_price between", value1, value2, "returnPrice");
            return (Criteria) this;
        }

        public Criteria andReturnPriceNotBetween(Double value1, Double value2) {
            addCriterion("return_price not between", value1, value2, "returnPrice");
            return (Criteria) this;
        }

        public Criteria andOpenRangeIsNull() {
            addCriterion("open_range is null");
            return (Criteria) this;
        }

        public Criteria andOpenRangeIsNotNull() {
            addCriterion("open_range is not null");
            return (Criteria) this;
        }

        public Criteria andOpenRangeEqualTo(String value) {
            addCriterion("open_range =", value, "openRange");
            return (Criteria) this;
        }

        public Criteria andOpenRangeNotEqualTo(String value) {
            addCriterion("open_range <>", value, "openRange");
            return (Criteria) this;
        }

        public Criteria andOpenRangeGreaterThan(String value) {
            addCriterion("open_range >", value, "openRange");
            return (Criteria) this;
        }

        public Criteria andOpenRangeGreaterThanOrEqualTo(String value) {
            addCriterion("open_range >=", value, "openRange");
            return (Criteria) this;
        }

        public Criteria andOpenRangeLessThan(String value) {
            addCriterion("open_range <", value, "openRange");
            return (Criteria) this;
        }

        public Criteria andOpenRangeLessThanOrEqualTo(String value) {
            addCriterion("open_range <=", value, "openRange");
            return (Criteria) this;
        }

        public Criteria andOpenRangeLike(String value) {
            addCriterion("open_range like", value, "openRange");
            return (Criteria) this;
        }

        public Criteria andOpenRangeNotLike(String value) {
            addCriterion("open_range not like", value, "openRange");
            return (Criteria) this;
        }

        public Criteria andOpenRangeIn(List<String> values) {
            addCriterion("open_range in", values, "openRange");
            return (Criteria) this;
        }

        public Criteria andOpenRangeNotIn(List<String> values) {
            addCriterion("open_range not in", values, "openRange");
            return (Criteria) this;
        }

        public Criteria andOpenRangeBetween(String value1, String value2) {
            addCriterion("open_range between", value1, value2, "openRange");
            return (Criteria) this;
        }

        public Criteria andOpenRangeNotBetween(String value1, String value2) {
            addCriterion("open_range not between", value1, value2, "openRange");
            return (Criteria) this;
        }

        public Criteria andPrinterMethodIdIsNull() {
            addCriterion("printer_method_id is null");
            return (Criteria) this;
        }

        public Criteria andPrinterMethodIdIsNotNull() {
            addCriterion("printer_method_id is not null");
            return (Criteria) this;
        }

        public Criteria andPrinterMethodIdEqualTo(String value) {
            addCriterion("printer_method_id =", value, "printerMethodId");
            return (Criteria) this;
        }

        public Criteria andPrinterMethodIdNotEqualTo(String value) {
            addCriterion("printer_method_id <>", value, "printerMethodId");
            return (Criteria) this;
        }

        public Criteria andPrinterMethodIdGreaterThan(String value) {
            addCriterion("printer_method_id >", value, "printerMethodId");
            return (Criteria) this;
        }

        public Criteria andPrinterMethodIdGreaterThanOrEqualTo(String value) {
            addCriterion("printer_method_id >=", value, "printerMethodId");
            return (Criteria) this;
        }

        public Criteria andPrinterMethodIdLessThan(String value) {
            addCriterion("printer_method_id <", value, "printerMethodId");
            return (Criteria) this;
        }

        public Criteria andPrinterMethodIdLessThanOrEqualTo(String value) {
            addCriterion("printer_method_id <=", value, "printerMethodId");
            return (Criteria) this;
        }

        public Criteria andPrinterMethodIdLike(String value) {
            addCriterion("printer_method_id like", value, "printerMethodId");
            return (Criteria) this;
        }

        public Criteria andPrinterMethodIdNotLike(String value) {
            addCriterion("printer_method_id not like", value, "printerMethodId");
            return (Criteria) this;
        }

        public Criteria andPrinterMethodIdIn(List<String> values) {
            addCriterion("printer_method_id in", values, "printerMethodId");
            return (Criteria) this;
        }

        public Criteria andPrinterMethodIdNotIn(List<String> values) {
            addCriterion("printer_method_id not in", values, "printerMethodId");
            return (Criteria) this;
        }

        public Criteria andPrinterMethodIdBetween(String value1, String value2) {
            addCriterion("printer_method_id between", value1, value2, "printerMethodId");
            return (Criteria) this;
        }

        public Criteria andPrinterMethodIdNotBetween(String value1, String value2) {
            addCriterion("printer_method_id not between", value1, value2, "printerMethodId");
            return (Criteria) this;
        }

        public Criteria andCreateDateIsNull() {
            addCriterion("create_date is null");
            return (Criteria) this;
        }

        public Criteria andCreateDateIsNotNull() {
            addCriterion("create_date is not null");
            return (Criteria) this;
        }

        public Criteria andCreateDateEqualTo(Date value) {
            addCriterion("create_date =", value, "createDate");
            return (Criteria) this;
        }

        public Criteria andCreateDateNotEqualTo(Date value) {
            addCriterion("create_date <>", value, "createDate");
            return (Criteria) this;
        }

        public Criteria andCreateDateGreaterThan(Date value) {
            addCriterion("create_date >", value, "createDate");
            return (Criteria) this;
        }

        public Criteria andCreateDateGreaterThanOrEqualTo(Date value) {
            addCriterion("create_date >=", value, "createDate");
            return (Criteria) this;
        }

        public Criteria andCreateDateLessThan(Date value) {
            addCriterion("create_date <", value, "createDate");
            return (Criteria) this;
        }

        public Criteria andCreateDateLessThanOrEqualTo(Date value) {
            addCriterion("create_date <=", value, "createDate");
            return (Criteria) this;
        }

        public Criteria andCreateDateIn(List<Date> values) {
            addCriterion("create_date in", values, "createDate");
            return (Criteria) this;
        }

        public Criteria andCreateDateNotIn(List<Date> values) {
            addCriterion("create_date not in", values, "createDate");
            return (Criteria) this;
        }

        public Criteria andCreateDateBetween(Date value1, Date value2) {
            addCriterion("create_date between", value1, value2, "createDate");
            return (Criteria) this;
        }

        public Criteria andCreateDateNotBetween(Date value1, Date value2) {
            addCriterion("create_date not between", value1, value2, "createDate");
            return (Criteria) this;
        }

        public Criteria andUpdateDateIsNull() {
            addCriterion("update_date is null");
            return (Criteria) this;
        }

        public Criteria andUpdateDateIsNotNull() {
            addCriterion("update_date is not null");
            return (Criteria) this;
        }

        public Criteria andUpdateDateEqualTo(Date value) {
            addCriterion("update_date =", value, "updateDate");
            return (Criteria) this;
        }

        public Criteria andUpdateDateNotEqualTo(Date value) {
            addCriterion("update_date <>", value, "updateDate");
            return (Criteria) this;
        }

        public Criteria andUpdateDateGreaterThan(Date value) {
            addCriterion("update_date >", value, "updateDate");
            return (Criteria) this;
        }

        public Criteria andUpdateDateGreaterThanOrEqualTo(Date value) {
            addCriterion("update_date >=", value, "updateDate");
            return (Criteria) this;
        }

        public Criteria andUpdateDateLessThan(Date value) {
            addCriterion("update_date <", value, "updateDate");
            return (Criteria) this;
        }

        public Criteria andUpdateDateLessThanOrEqualTo(Date value) {
            addCriterion("update_date <=", value, "updateDate");
            return (Criteria) this;
        }

        public Criteria andUpdateDateIn(List<Date> values) {
            addCriterion("update_date in", values, "updateDate");
            return (Criteria) this;
        }

        public Criteria andUpdateDateNotIn(List<Date> values) {
            addCriterion("update_date not in", values, "updateDate");
            return (Criteria) this;
        }

        public Criteria andUpdateDateBetween(Date value1, Date value2) {
            addCriterion("update_date between", value1, value2, "updateDate");
            return (Criteria) this;
        }

        public Criteria andUpdateDateNotBetween(Date value1, Date value2) {
            addCriterion("update_date not between", value1, value2, "updateDate");
            return (Criteria) this;
        }
    }

    public static class Criteria extends GeneratedCriteria {

        protected Criteria() {
            super();
        }
    }

    public static class Criterion {
        private String condition;

        private Object value;

        private Object secondValue;

        private boolean noValue;

        private boolean singleValue;

        private boolean betweenValue;

        private boolean listValue;

        private String typeHandler;

        public String getCondition() {
            return condition;
        }

        public Object getValue() {
            return value;
        }

        public Object getSecondValue() {
            return secondValue;
        }

        public boolean isNoValue() {
            return noValue;
        }

        public boolean isSingleValue() {
            return singleValue;
        }

        public boolean isBetweenValue() {
            return betweenValue;
        }

        public boolean isListValue() {
            return listValue;
        }

        public String getTypeHandler() {
            return typeHandler;
        }

        protected Criterion(String condition) {
            super();
            this.condition = condition;
            this.typeHandler = null;
            this.noValue = true;
        }

        protected Criterion(String condition, Object value, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.typeHandler = typeHandler;
            if (value instanceof List<?>) {
                this.listValue = true;
            } else {
                this.singleValue = true;
            }
        }

        protected Criterion(String condition, Object value) {
            this(condition, value, null);
        }

        protected Criterion(String condition, Object value, Object secondValue, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.secondValue = secondValue;
            this.typeHandler = typeHandler;
            this.betweenValue = true;
        }

        protected Criterion(String condition, Object value, Object secondValue) {
            this(condition, value, secondValue, null);
        }
    }
}